USE [exportDb]
GO

/****** Object:  UserDefinedTableType [dbo].[ProductMovement]    Script Date: 01/03/2014 14:46:17 ******/
DROP TYPE [dbo].[ProductMovement]
GO

/****** Object:  UserDefinedTableType [dbo].[ProductMovement]    Script Date: 01/03/2014 14:46:17 ******/
CREATE TYPE [dbo].[ProductMovement] AS TABLE(
	[AutoID] [int] IDENTITY(1,1) NOT NULL,
	[PalletDetailID] [decimal](18, 0) NOT NULL,
	[PalletID] [nvarchar](23) NOT NULL,
	[ItemNo] [int] NOT NULL,
	[ProductCode] [nvarchar](18) NOT NULL,
	[Lot] [nvarchar](10) NOT NULL,
	[MachineCode] [nvarchar](4) NOT NULL,
	[ProductQty] [decimal](18, 0) NULL,
	[PlantCode] [nvarchar](4) NULL,
	[PlantDestination] [nvarchar](4) NULL,
	[MovementType] [nvarchar](5) NULL,
	PRIMARY KEY CLUSTERED 
(
	[PalletDetailID] ASC
)WITH (IGNORE_DUP_KEY = OFF)
)
GO


